![](/template/termwiki/images/likesmall.jpg)
Home > Answers > How to Highlight or Remove Duplicates in Excel 2007 twa1320311909
How to Highlight or Remove Duplicates in Excel 2007?
I have an Excel file with 20K records. How do I select all entries with repeated records and then remove only the duplicated ones?
- Industry/Domain: Software
- Category: Spreadsheet
- Created: 04:18, 3 November 2011
Creator
Featured blossaries
Dan Sotnikov
0
Terms
18
Blossaries
1
Followers
Interesting facts about Russia
Category: Geography 1
4 Terms
![](/template/termwiki/images/likesmall.jpg)
![](https://accounts.termwiki.com/thumb1.php?f=artleo.com-26707-1380778401.jpg&width=304&height=180)
stanley soerianto
0
Terms
107
Blossaries
6
Followers
The Best Fitness Tracker You Can Buy
Category: Technology 2
5 Terms
![](/template/termwiki/images/likesmall.jpg)
![](https://accounts.termwiki.com/thumb1.php?f=4bcae840-1408071607.jpg&width=304&height=180)
tula.ndex
0
Terms
51
Blossaries
11
Followers
Bulawayo Public Transportation
Category: Travel 2
6 Terms
![](/template/termwiki/images/likesmall.jpg)
![](https://accounts.termwiki.com/thumb1.php?f=AWB5J0ICA99GB97CAMY6-1378790513.jpg&width=304&height=180)